[dbo].[BAEGetUserAccessRights]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEGetUserAccessRights

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@UID	varchar(8)	8

SQL Script

create procedure [dbo].[BAEGetUserAccessRights] @UID varchar(8) as
--SELECT 1 Granted
SELECT     *
FROM        Name_Security_Groups
WHERE    ID = @UID AND SECURITY_GROUP = 'administrator';

IF @@rowcount > 0
BEGIN
    SELECT 1 GRANTED;
END
ELSE
BEGIN
    SELECT 0 GRANTED;
END

GO

Uses

[dbo].[Name_Security_Groups]
dbo